POSTGRESQL-IE: An Image-handling Extension for PostgreSQL

XML Support in PostgreSQL

Easy and Fast Design and Implementation of PostgreSQL based image handling application

In modern computing, RDBMS are great to store different types of data. To a developer, one of the major objectives is to provide a very low cost and easy to use solution to an existing problem. While commercial databases are more easy to use along with their new as well as documented features come with complicated licensing cost, free open source databases are not that straightforward under man...

Benchmarking PostgreSQL for data warehousing

Often in a competitive market, corporations need tools to increase the accuracy and efficiency of the decisions. Facing this, several companies that have no resources to buy the commercial systems available because of the high costs, have no chance to buy a Decision Support Systems (DSS) platform. This paper is dedicated to a benchmark of PostgreSQL DBMS for data warehouse as part of a low cost...

PostGIS-T: towards a spatiotemporal PostgreSQL database extension

The temporal dimension of spatial data has been the subject of discussion in the literature for a long time. While there are numerous Database Management System (DBMS) solutions only for spatial dimension, we did not observe the same situation for spatiotemporal data. Considering this gap, our purpose is to design and implement an extension to the DBMS PostgreSQL that is based on a formal spati...

Serializable Snapshot Isolation in PostgreSQL

This paper describes our experience implementing PostgreSQL’s new serializable isolation level. It is based on the recently-developed Serializable Snapshot Isolation (SSI) technique. This is the first implementation of SSI in a production database release as well as the first in a database that did not previously have a lock-based serializable isolation level. We reflect on our experience and d...